
/*
 *  mini-SaaS
 *  Application for developing Software as a Service (SaaS) 
 *  Copyright (c) 2011 Anand Sudhakaran, Bryce Holton, Chao Zhang
 *  ASU
 *
 *  This file is part of mini-SaaS.
 *
 *  mini-SaaS is free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 3 of the License, or
 *  (at your option) any later version.
 *  
 *  mini-SaaS is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.

 *  You should have received a copy of the GNU General Public License
 *  along with mini-SaaS; if not, see <http://www.gnu.org/licenses/>. 
 *
 */
 
package loginbean;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ManageData {
 private Connection conn = null;
	
	public ManageData()
	{
		try 
		{
			DBManager db = new DBManager();
			conn = db.getDatabaseConnection();
		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}

	}
	public void AddData(int fieldId, String newValue, int tenantId)
	{
		Statement st;
		try {
			
			String strQuery = "INSERT INTO DataTable (`FieldID`, `Value`, `tenantId`) VALUES ("+fieldId+", '"+newValue+"',"+ tenantId +");";
			st = conn.createStatement();
			st.execute(strQuery);

		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}		
	}
        
        public void closeDb()
	{
		try 
		{
			conn.close();
		} 
		catch (SQLException e)
		{
			e.printStackTrace();
		}
	}
    
}
